Solutions to NOT IN Questions

1. SELECT name, primary_poc, sales_rep_id
   FROM accounts
   WHERE name NOT IN ('Walmart', 'Target', 'Nordstrom');

2.

SELECT *
FROM web_events
WHERE channel NOT IN ('organic', 'adwords');

Solutions to NOT LIKE Questions

1. SELECT name
   FROM accounts
   WHERE name NOT LIKE 'C%';

2.

SELECT name
FROM accounts
WHERE name NOT LIKE '%one%';

3. SELECT name
   FROM accounts
   WHERE name NOT LIKE '%s';